namespace CRM.DataAccess.Entities
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("PRODUCTS")]
    public partial class PRODUCT
    {
        public long ID { get; set; }

        public bool DELETED { get; set; }

        public long? CREATED_BY { get; set; }

        public DateTime DATE_ENTERED { get; set; }

        public long? MODIFIED_USER_ID { get; set; }

        public DateTime DATE_MODIFIED { get; set; }

        [StringLength(250)]
        public string PRODUCT_NAME { get; set; }

        [StringLength(1000)]
        public string DESCRIPTION { get; set; }

        public bool? PRODUCT_ACTIVE { get; set; }

        [StringLength(50)]
        public string PART_NUMBER { get; set; }

        public DateTime? SALES_START_DATE { get; set; }

        public long? MANUFACTURER_ID { get; set; }

        [StringLength(250)]
        public string PRODUCT_CATEGORY { get; set; }

        public DateTime? SUPPORT_START_DATE { get; set; }

        public DateTime? SALES_END_DATE { get; set; }

        public DateTime? SUPPORT_EXPIRY_DATE { get; set; }

        public long? VENDOR_ID { get; set; }

        [StringLength(250)]
        public string WEBSITE { get; set; }

        [StringLength(50)]
        public string VENDOR_PARTNO { get; set; }

        [StringLength(50)]
        public string MFR_PARTNO { get; set; }

        [StringLength(150)]
        public string PRODUCT_SHEET { get; set; }

        [StringLength(50)]
        public string SERIAL_NO { get; set; }

        public double? UNIT_PRICE { get; set; }

        public double? DISCOUNT_PRICE { get; set; }

        public double? COMMISSION_RATE { get; set; }

        public double? GST_PERCENT { get; set; }

        public double? SALES_PERCENT { get; set; }

        public double? SERVICE_PERCENT { get; set; }

        public long? USAGE_UNIT_ID { get; set; }

        public double? QTY_OUT_STOCK { get; set; }

        public double? BALANCE { get; set; }

        public double? QTY_IN_STOCK { get; set; }

        public double? REORDER_LEVEL { get; set; }

        public long? ASSIGN_TO { get; set; }

        public double? QTY_IN_DEMAND { get; set; }

        public byte[] PICTURE { get; set; }

        public string IMAGE { get; set; }
    }
}
